For an empty table , this approach is significantly faster than creating the clustered index after importing the data , as it eliminates the sorting step 對于空表,此方法明顯快于導(dǎo)入數(shù)據(jù)后再創(chuàng)建聚集索引,因為它不需要執(zhí)行排序。
To minimize blocking , you can specify a smaller batch size and use the order hint to eliminate the sorting step during the bulk import operation 為了盡可能減少阻塞,可以指定較小的批大小,并使用order提示去掉大容量導(dǎo)入操作中的排序步驟。